1	SELECT * FROM default_module WHERE site='FRONTPAGE' AND name='tour'	0.0027151107788086
2	SELECT * FROM default_setting WHERE setting_id='1'	0.00059914588928223
3	SELECT region_id,title,slug,country_id FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id IN (1,4,14,18) order by order_no asc	0.0017011165618896
4	SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1	0.00021100044250488
5	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0020310878753662
6	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00017499923706055
7	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0020148754119873
8	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.0001518726348877
9	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0016820430755615
10	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00015497207641602
11	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'' and city_id IN (SELECT city_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0013761520385742
12	SELECT continent_id,title,slug FROM default_continent WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0011188983917236
13	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='3' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0014388561248779
14	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='4' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0012600421905518
15	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='5' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0012428760528564
16	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='6' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0011920928955078
17	SELECT country_id,title,slug FROM default_country WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id<>4 and continent_id='7' and country_id IN (SELECT country_id FROM default_tour_destination WHERE is_trash=0) order by order_no ASC	0.0011861324310303
18	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=477 order by order_no asc	0.0010788440704346
19	SELECT servicecat_id,title,slug,intro,image FROM default_servicecat WHERE lang_id='vn' and is_trash=0 and is_online=1 and servicecat_id IN (7,8,9,10)	0.0011389255523682
20	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='cruise' and act_page='cat' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00045919418334961
21	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00014710426330566
22	SELECT cruise_cat_id,title,slug,image_banner FROM default_cruise_cat WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0010771751403809
23	SELECT tour_property_id FROM default_tour_property WHERE lang_id='vn' and is_trash=0 and is_online=1 and type='VISITORTYPE' order by order_no ASC limit 0,3	0.0012621879577637
24	SELECT distinct short FROM default_property where property_id=950 LIMIT 0,1	0.00014400482177734
25	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00052499771118164
26	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011301040649414
27	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='tour' and act_page='tour_departure_point' and type='customize' and type_page='' order by order_no ASC limit 0,1	0.00043392181396484
28	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013399124145508
29	SELECT city_id,title,banner,intro,content FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and slug='lang-son' LIMIT 0,1	0.0014419555664062
30	SELECT guidecat_idintro,title,image FROM default_guidecat WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0010321140289307
31	SELECT guide_id,slug,title,publish_date FROM default_guide WHERE lang_id='vn' and is_trash=0 and is_online=1 and cat_id='' and country_id='4' and city_id='917' order by order_no asc	0.0019450187683105
32	SELECT region_id,title FROM default_region WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' order by order_no asc	0.0010972023010254
33	SELECT tourcat_id,title FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 order by order_no asc	0.0010890960693359
34	SELECT tour_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='917')	0.0012650489807129
35	SELECT tour_id,departure_point_id,slug,title,image,duration_type,duration_custom,number_day,number_night,list_tag_id FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1 and tour_id in (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='917') order by order_no asc LIMIT 0,15	0.0015230178833008
36	SELECT max(number_day) as max,min(number_day) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1	0.0013470649719238
37	SELECT max(min_price) as max,min(min_price) as min FROM default_tour WHERE lang_id='vn' and is_trash=0 and is_online=1	0.0010969638824463
38	SELECT tourcat_id,title,slug FROM default_tour_category WHERE lang_id='vn' and is_trash=0 and is_online=1 and parent_id=0 order by order_no asc	0.0010509490966797
39	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00045204162597656
40	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010895729064941
41	SELECT page_id,title,slug FROM default_page WHERE lang_id='vn' and is_trash=0 and is_online=1 and page_id <>'2' order by order_no asc	0.0010299682617188
42	SELECT meta_id,config_value_title,config_value_intro,image,meta_index,meta_follow,image FROM default_meta WHERE lang_id='vn' and (config_link='/du-lich-trong-nuoc/du-lich-lang-son' or config_link='/du-lich-trong-nuoc/du-lich-lang-son') limit 1	0.0011608600616455
43	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00049090385437012
44	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.9897384643555E-5
45	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00046610832214355
46	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00015115737915039
47	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0003809928894043
48	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00010585784912109
49	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00043177604675293
50	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00011205673217773
51	SELECT slug FROM default_servicecat WHERE servicecat_id='10'	0.0001227855682373
52	SELECT title FROM default_servicecat WHERE servicecat_id='10'	0.00014805793762207
53	SELECT title FROM default_servicecat WHERE servicecat_id='10'	3.3855438232422E-5
54	SELECT title FROM default_country WHERE country_id='4'	0.00015091896057129
55	SELECT citystore_id,city_id FROM default_citystore WHERE lang_id='vn' and is_trash=0 and type='DEPARTUREPOINT' and country_id='4' and city_id IN (SELECT city_id FROM default_city WHERE is_trash=0 and is_online=1) order by order_no ASC	0.001345157623291
56	SELECT city_id,title,slug FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and city_id IN(651,653,700,1)	0.00098609924316406
57	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='917')	0.00032401084899902
58	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='915')	0.0003659725189209
59	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='914')	0.00035214424133301
60	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='804')	0.00034713745117188
61	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='699')	0.00033211708068848
62	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='760')	0.00026798248291016
63	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='685')	0.0002601146697998
64	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='683')	0.00025296211242676
65	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='758')	0.00025796890258789
66	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='682')	0.00024700164794922
67	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='700')	0.00024318695068359
68	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='920')	0.00024914741516113
69	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='919')	0.00030207633972168
70	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='906')	0.00025701522827148
71	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='802')	0.00025105476379395
72	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='659')	0.0002751350402832
73	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='653')	0.0002448558807373
74	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='910')	0.00028896331787109
75	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='908')	0.0003058910369873
76	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='907')	0.00025200843811035
77	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='801')	0.00033688545227051
78	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='member' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00060296058654785
79	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.00013899803161621
80	SELECT reviews_id FROM default_reviews WHERE lang_id='vn' and is_trash=0 and is_online=1 and profile_id = 0 and table_id = '551' and type='tour'	0.0029969215393066
81	SELECT tour_store_id FROM default_tour_store WHERE lang_id='vn' and tour_id='551' and _type='DEPARTURE' limit 0,1	0.0011398792266846
82	SELECT title FROM default_tag WHERE tag_id='126'	0.00014901161193848
83	SELECT title FROM default_country WHERE country_id='4'	0.0001380443572998
84	SELECT distinct country_id FROM default_region where region_id=14 LIMIT 0,1	0.00011897087097168
85	SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='14' and city_id<>'917' order by order_no ASC	0.0012900829315186
86	SELECT title FROM default_region WHERE region_id='14'	0.00010991096496582
87	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='966')	0.00029802322387695
88	SELECT distinct country_id FROM default_region where region_id=5 LIMIT 0,1	0.00010991096496582
89	SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='5' and city_id<>'917' order by order_no ASC	0.0012831687927246
90	SELECT title FROM default_region WHERE region_id='5'	0.00011801719665527
91	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='915')	0.00029611587524414
92	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='914')	0.00028800964355469
93	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='913')	0.00027680397033691
94	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='912')	0.00027108192443848
95	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='804')	0.0002591609954834
96	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='895')	0.00024199485778809
97	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='761')	0.00023889541625977
98	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='699')	0.00027608871459961
99	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='760')	0.0002589225769043
100	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='698')	0.00027108192443848
101	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='684')	0.00024080276489258
102	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='759')	0.00023198127746582
103	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='685')	0.00023794174194336
104	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='683')	0.00027918815612793
105	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='682')	0.0002741813659668
106	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='758')	0.00028300285339355
107	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='673')	0.00027108192443848
108	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='666')	0.00027894973754883
109	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='700')	0.00024199485778809
110	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='656')	0.00022482872009277
111	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='652')	0.00023794174194336
112	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='1')	0.00024890899658203
113	SELECT distinct country_id FROM default_region where region_id=6 LIMIT 0,1	0.00010514259338379
114	SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='6' and city_id<>'917' order by order_no ASC	0.0012562274932861
115	SELECT title FROM default_region WHERE region_id='6'	8.2969665527344E-5
116	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='920')	0.00029706954956055
117	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='919')	0.0002589225769043
118	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='906')	0.00024986267089844
119	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='905')	0.00024104118347168
120	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='904')	0.00023913383483887
121	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='805')	0.00024986267089844
122	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='802')	0.00024986267089844
123	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='697')	0.00024795532226562
124	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='675')	0.00023603439331055
125	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='670')	0.00025701522827148
126	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='690')	0.00024104118347168
127	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='660')	0.00024604797363281
128	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='659')	0.00024080276489258
129	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='654')	0.00024199485778809
130	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='678')	0.00023007392883301
131	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='653')	0.00027608871459961
132	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='686')	0.00026798248291016
133	SELECT distinct country_id FROM default_region where region_id=7 LIMIT 0,1	0.00011301040649414
134	SELECT city_id,title,slug,country_id FROM default_city WHERE lang_id='vn' and is_trash=0 and is_online=1 and country_id='4' and region_id='7' and city_id<>'917' order by order_no ASC	0.0012979507446289
135	SELECT title FROM default_region WHERE region_id='7'	0.00011205673217773
136	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='958')	0.00026512145996094
137	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='911')	0.00026607513427734
138	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='910')	0.00025081634521484
139	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='909')	0.00024294853210449
140	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='908')	0.00024294853210449
141	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='907')	0.00024890899658203
142	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='903')	0.00023603439331055
143	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='803')	0.00026679039001465
144	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='801')	0.00027108192443848
145	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='764')	0.00026512145996094
146	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='765')	0.00026106834411621
147	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='763')	0.00027799606323242
148	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='762')	0.00024008750915527
149	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='677')	0.00022006034851074
150	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='663')	0.00021886825561523
151	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='661')	0.00027203559875488
152	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='658')	0.0002591609954834
153	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='657')	0.00023698806762695
154	SELECT COUNT(*) AS totalitem FROM default_tour WHERE is_trash=0 and is_online=1 and tour_id IN (SELECT tour_id FROM default_tour_destination WHERE country_id='4' and city_id='651')	0.00023198127746582
155	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='page' and act_page='about' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00044417381286621
156	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	0.0001070499420166
157	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='testimonial' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00043487548828125
158	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.2983245849609E-5
159	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='faqs' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.0003819465637207
160	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.1075897216797E-5
161	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='download' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00047087669372559
162	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.2983245849609E-5
163	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='news' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00044012069702148
164	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	9.0122222900391E-5
165	SELECT feature_package_id FROM default_featurepackage WHERE mod_page='blog' and act_page='default' and type='default' and type_page='' order by order_no ASC limit 0,1	0.00037789344787598
166	SELECT distinct list_feature_package_id FROM default_package where package_id=2 LIMIT 0,1	8.8214874267578E-5

Lạng Sơn

tour du lịch Lạng Sơn

HÀ NỘI - BẮC KẠN - CAO BẰNG - LẠNG SƠN - HẠ LONG

a-z tourism destinations in Việt Nam

Mekong

Miền Bắc

Miền Trung

Miền Nam

Về chúng tôi

Kiểu du lịch

Khác

Theo dõi

Kênh thanh toán